package com.xinzhitong.www.mapper;

import com.xinzhitong.www.pojo.News;
import com.xinzhitong.www.pojo.Profession;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * 游客表的相关操作
 *
 * @author 魏骆淳
 */
@Repository
public interface VisitorMapper {

    @Select("select * from profession")
    List<Profession> selectProfessionInformation();

    @Select("select id, picture, title from news")
    List<News> selectNewsOutline();

    @Select("select count(id) as count from news")
    Integer selectCountNews();

}
